﻿#region The MIT License
// The MIT License
// 
// Copyright (c) 2009 octalforty studios
// 
// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this software and associated documentation files (the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions:
// 
// The above copyright notice and this permission notice shall be included in
// all copies or substantial portions of the Software.
// 
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
// THE SOFTWARE.
#endregion
using System;

using NUnit.Framework;

using octalforty.Chinchillin.Actions.Db;

namespace octalforty.Chinchillin.Tests.Actions.Db
{
    [TestFixture()]
    public class SqlServer2008PlatformTestFixture
    {
        [Test()]
        public void GetConnectionInfo()
        {
            var platform = new SqlServer2008Platform();
            var connectionInfo = platform.GetConnectionInfo(new Uri("sqlserver2008://localhost/waffle"));

            Assert.IsInstanceOf(typeof(SqlServer2008ConnectionInfo), connectionInfo);

            var sqlServerConnectionInfo = (SqlServer2008ConnectionInfo)connectionInfo;

            Assert.IsNullOrEmpty(connectionInfo.Login);
            Assert.IsNullOrEmpty(connectionInfo.Password);
            Assert.AreEqual("localhost", sqlServerConnectionInfo.ServerName);
            Assert.IsNull(sqlServerConnectionInfo.Port);
            Assert.AreEqual("waffle", connectionInfo.DatabaseName);
        }

        [Test()]
        public void GetConnectionInfoWithInstanceNamePortLoginAndPassword()
        {
            var platform = new SqlServer2008Platform();
            var connectionInfo = platform.GetConnectionInfo(new Uri("sqlserver2008://sa:sapwd@localhost:1433/sqlexpress/waffle"));

            Assert.IsInstanceOf(typeof(SqlServer2008ConnectionInfo), connectionInfo);

            var sqlServerConnectionInfo = (SqlServer2008ConnectionInfo)connectionInfo;

            Assert.AreEqual("sa", connectionInfo.Login);
            Assert.AreEqual("sapwd", connectionInfo.Password);
            Assert.AreEqual(@"localhost\sqlexpress", sqlServerConnectionInfo.ServerName);
            Assert.AreEqual(1433, sqlServerConnectionInfo.Port);
            Assert.AreEqual("waffle", connectionInfo.DatabaseName);
        }
    }
}

